﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;

namespace DAL
{
     [Serializable]
     public class TEInfoData
     {

         public const string IDField ="@ID";

         public const string PRIMARYKEY_Field=@"ID";

         public const string ANZHUANGTIMEField ="@anzhuangTime";

         public const string GUISHUDIField ="@guishudi";

         public const string HANGYEField ="@hangye";

         public const string SHIYONGDANWEIField ="@shiyongdanwei";

         public const string BUFANGWEIZHIField ="@bufangweizhi";

         public const string WEIHUGONGSIField ="@weihugongsi";

         public const string REMARKField ="@remark";

         public const string ZHUCEIDField ="@zhuceID";

         public const string SHENGCHANXULIEHAOField ="@shengchanxuliehao";

         public const string XINGHAOField ="@xinghao";

         public const string FUJIANQINGDANField ="@fujianqingdan";

         public const string WANGLUOINFOField ="@wangluoinfo";

         public const string SHIYONGDANWEIDIZHIField ="@shiyongdanweidizhi";

         public const string LIANXIRENField ="@lianxiren";

         public const string PIC1Field ="@pic1";

         public const string PIC2Field ="@pic2";

         public const string PIC3Field ="@pic3";

         public const string WORKERSIDField ="@WorkersID";

         public const string BAK1Field ="@bak1";

         public const string BAK2Field ="@bak2";

         public const string BAK3Field ="@bak3";

         public const string BAK4Field ="@bak4";

         public const string BAK5Field ="@bak5";

         public const string BAK6Field ="@bak6";

         private String _ID;

         private DateTime _anzhuangTime;

         private String _guishudi;

         private String _hangye;

         private String _shiyongdanwei;

         private String _bufangweizhi;

         private String _weihugongsi;

         private String _remark;

         private String _zhuceID;

         private String _shengchanxuliehao;

         private String _xinghao;

         private Int32 _fujianqingdan;

         private String _wangluoinfo;

         private String _shiyongdanweidizhi;

         private String _lianxiren;

         private String _pic1;

         private String _pic2;

         private String _pic3;

         private Guid _WorkersID;

         private String _bak1;

         private String _bak2;

         private String _bak3;

         private String _bak4;

         private String _bak5;

         private String _bak6;

         public String ID
         {
             get{ return _ID;}
             set{ _ID=value;}
         }
         public DateTime anzhuangTime
         {
             get{ return _anzhuangTime;}
             set{ _anzhuangTime=value;}
         }
         public String guishudi
         {
             get{ return _guishudi;}
             set{ _guishudi=value;}
         }
         public String hangye
         {
             get{ return _hangye;}
             set{ _hangye=value;}
         }
         public String shiyongdanwei
         {
             get{ return _shiyongdanwei;}
             set{ _shiyongdanwei=value;}
         }
         public String bufangweizhi
         {
             get{ return _bufangweizhi;}
             set{ _bufangweizhi=value;}
         }
         public String weihugongsi
         {
             get{ return _weihugongsi;}
             set{ _weihugongsi=value;}
         }
         public String remark
         {
             get{ return _remark;}
             set{ _remark=value;}
         }
         public String zhuceID
         {
             get{ return _zhuceID;}
             set{ _zhuceID=value;}
         }
         public String shengchanxuliehao
         {
             get{ return _shengchanxuliehao;}
             set{ _shengchanxuliehao=value;}
         }
         public String xinghao
         {
             get{ return _xinghao;}
             set{ _xinghao=value;}
         }
         public Int32 fujianqingdan
         {
             get{ return _fujianqingdan;}
             set{ _fujianqingdan=value;}
         }
         public String wangluoinfo
         {
             get{ return _wangluoinfo;}
             set{ _wangluoinfo=value;}
         }
         public String shiyongdanweidizhi
         {
             get{ return _shiyongdanweidizhi;}
             set{ _shiyongdanweidizhi=value;}
         }
         public String lianxiren
         {
             get{ return _lianxiren;}
             set{ _lianxiren=value;}
         }
         public String pic1
         {
             get{ return _pic1;}
             set{ _pic1=value;}
         }
         public String pic2
         {
             get{ return _pic2;}
             set{ _pic2=value;}
         }
         public String pic3
         {
             get{ return _pic3;}
             set{ _pic3=value;}
         }
         public Guid WorkersID
         {
             get{ return _WorkersID;}
             set{ _WorkersID=value;}
         }
         public String bak1
         {
             get{ return _bak1;}
             set{ _bak1=value;}
         }
         public String bak2
         {
             get{ return _bak2;}
             set{ _bak2=value;}
         }
         public String bak3
         {
             get{ return _bak3;}
             set{ _bak3=value;}
         }
         public String bak4
         {
             get{ return _bak4;}
             set{ _bak4=value;}
         }
         public String bak5
         {
             get{ return _bak5;}
             set{ _bak5=value;}
         }
         public String bak6
         {
             get{ return _bak6;}
             set{ _bak6=value;}
         }
         public TEInfoData()
         {
             _ID="";
             _anzhuangTime=DateTime.Now;
             _guishudi="";
             _hangye="";
             _shiyongdanwei="";
             _bufangweizhi="";
             _weihugongsi="";
             _remark="";
             _zhuceID="";
             _shengchanxuliehao="";
             _xinghao="";
             _fujianqingdan=0;
             _wangluoinfo="";
             _shiyongdanweidizhi="";
             _lianxiren="";
             _pic1="";
             _pic2="";
             _pic3="";
             _WorkersID=Guid.Empty;
             _bak1="";
             _bak2="";
             _bak3="";
             _bak4="";
             _bak5="";
             _bak6="";
         }
     }

     public class TEInfoDataFactory
     {
         public static TEInfoData Construct(IDataReader reader)
         {
             TEInfoData data = new TEInfoData();

             try{  data.ID = Convert.ToString(reader["ID"])  ;} catch { } 

             try{  data.anzhuangTime = Convert.ToDateTime(reader["anzhuangTime"])  ;} catch { } 

             try{  data.guishudi = Convert.ToString(reader["guishudi"])  ;} catch { } 

             try{  data.hangye = Convert.ToString(reader["hangye"])  ;} catch { } 

             try{  data.shiyongdanwei = Convert.ToString(reader["shiyongdanwei"])  ;} catch { } 

             try{  data.bufangweizhi = Convert.ToString(reader["bufangweizhi"])  ;} catch { } 

             try{  data.weihugongsi = Convert.ToString(reader["weihugongsi"])  ;} catch { } 

             try{  data.remark = Convert.ToString(reader["remark"])  ;} catch { } 

             try{  data.zhuceID = Convert.ToString(reader["zhuceID"])  ;} catch { } 

             try{  data.shengchanxuliehao = Convert.ToString(reader["shengchanxuliehao"])  ;} catch { } 

             try{  data.xinghao = Convert.ToString(reader["xinghao"])  ;} catch { } 

             try{  data.fujianqingdan = Convert.ToInt32(reader["fujianqingdan"])  ;} catch { } 

             try{  data.wangluoinfo = Convert.ToString(reader["wangluoinfo"])  ;} catch { } 

             try{  data.shiyongdanweidizhi = Convert.ToString(reader["shiyongdanweidizhi"])  ;} catch { } 

             try{  data.lianxiren = Convert.ToString(reader["lianxiren"])  ;} catch { } 

             try{  data.pic1 = Convert.ToString(reader["pic1"])  ;} catch { } 

             try{  data.pic2 = Convert.ToString(reader["pic2"])  ;} catch { } 

             try{  data.pic3 = Convert.ToString(reader["pic3"])  ;} catch { } 

             try{  data.WorkersID = (Guid)(reader["WorkersID"]) ;} catch { } 

             try{  data.bak1 = Convert.ToString(reader["bak1"])  ;} catch { } 

             try{  data.bak2 = Convert.ToString(reader["bak2"])  ;} catch { } 

             try{  data.bak3 = Convert.ToString(reader["bak3"])  ;} catch { } 

             try{  data.bak4 = Convert.ToString(reader["bak4"])  ;} catch { } 

             try{  data.bak5 = Convert.ToString(reader["bak5"])  ;} catch { } 

             try{  data.bak6 = Convert.ToString(reader["bak6"])  ;} catch { } 

             return data;
         }
         public static String GetPrimaryKey(DataTable dt)
         {
             return GetPrimaryKey(dt,0);
         }
         public static String GetPrimaryKey(DataTable dt,int rowIndex)
         {
             String PrimaryKey="";

             if(dt.Rows.Count<rowIndex+1)

                 return "";

             DataRow dr=dt.Rows[rowIndex];

             if(dr==null)

                 return "";

             try{ PrimaryKey = Convert.ToString(dr[TEInfoData.PRIMARYKEY_Field]) ;} catch { } 

             return PrimaryKey;
         }
         public static TEInfoData Construct(DataTable dt)
         {
             return Construct(dt,0);
         }
         public static TEInfoData Construct(DataTable dt,int rowIndex)
         {
             TEInfoData data = new TEInfoData();

             if(dt.Rows.Count<rowIndex+1)

                 return null;

             DataRow dr=dt.Rows[rowIndex];

             if(dr==null)

                 return null;

             try{ data.ID = Convert.ToString(dr["ID"]) ;} catch { } 

             try{ data.anzhuangTime = Convert.ToDateTime(dr["anzhuangTime"]) ;} catch { } 

             try{ data.guishudi = Convert.ToString(dr["guishudi"]) ;} catch { } 

             try{ data.hangye = Convert.ToString(dr["hangye"]) ;} catch { } 

             try{ data.shiyongdanwei = Convert.ToString(dr["shiyongdanwei"]) ;} catch { } 

             try{ data.bufangweizhi = Convert.ToString(dr["bufangweizhi"]) ;} catch { } 

             try{ data.weihugongsi = Convert.ToString(dr["weihugongsi"]) ;} catch { } 

             try{ data.remark = Convert.ToString(dr["remark"]) ;} catch { } 

             try{ data.zhuceID = Convert.ToString(dr["zhuceID"]) ;} catch { } 

             try{ data.shengchanxuliehao = Convert.ToString(dr["shengchanxuliehao"]) ;} catch { } 

             try{ data.xinghao = Convert.ToString(dr["xinghao"]) ;} catch { } 

             try{ data.fujianqingdan = Convert.ToInt32(dr["fujianqingdan"]) ;} catch { } 

             try{ data.wangluoinfo = Convert.ToString(dr["wangluoinfo"]) ;} catch { } 

             try{ data.shiyongdanweidizhi = Convert.ToString(dr["shiyongdanweidizhi"]) ;} catch { } 

             try{ data.lianxiren = Convert.ToString(dr["lianxiren"]) ;} catch { } 

             try{ data.pic1 = Convert.ToString(dr["pic1"]) ;} catch { } 

             try{ data.pic2 = Convert.ToString(dr["pic2"]) ;} catch { } 

             try{ data.pic3 = Convert.ToString(dr["pic3"]) ;} catch { } 

             try{ data.WorkersID = new Guid(dr["WorkersID"].ToString()) ;} catch { } 

             try{ data.bak1 = Convert.ToString(dr["bak1"]) ;} catch { } 

             try{ data.bak2 = Convert.ToString(dr["bak2"]) ;} catch { } 

             try{ data.bak3 = Convert.ToString(dr["bak3"]) ;} catch { } 

             try{ data.bak4 = Convert.ToString(dr["bak4"]) ;} catch { } 

             try{ data.bak5 = Convert.ToString(dr["bak5"]) ;} catch { } 

             try{ data.bak6 = Convert.ToString(dr["bak6"]) ;} catch { } 

             return data;
         }
         public static TEInfoData Construct(DataRow dr)
         {
             TEInfoData data = new TEInfoData();

             try{ data.ID = Convert.ToString(dr["ID"]) ;} catch { } 

             try{ data.anzhuangTime = Convert.ToDateTime(dr["anzhuangTime"]) ;} catch { } 

             try{ data.guishudi = Convert.ToString(dr["guishudi"]) ;} catch { } 

             try{ data.hangye = Convert.ToString(dr["hangye"]) ;} catch { } 

             try{ data.shiyongdanwei = Convert.ToString(dr["shiyongdanwei"]) ;} catch { } 

             try{ data.bufangweizhi = Convert.ToString(dr["bufangweizhi"]) ;} catch { } 

             try{ data.weihugongsi = Convert.ToString(dr["weihugongsi"]) ;} catch { } 

             try{ data.remark = Convert.ToString(dr["remark"]) ;} catch { } 

             try{ data.zhuceID = Convert.ToString(dr["zhuceID"]) ;} catch { } 

             try{ data.shengchanxuliehao = Convert.ToString(dr["shengchanxuliehao"]) ;} catch { } 

             try{ data.xinghao = Convert.ToString(dr["xinghao"]) ;} catch { } 

             try{ data.fujianqingdan = Convert.ToInt32(dr["fujianqingdan"]) ;} catch { } 

             try{ data.wangluoinfo = Convert.ToString(dr["wangluoinfo"]) ;} catch { } 

             try{ data.shiyongdanweidizhi = Convert.ToString(dr["shiyongdanweidizhi"]) ;} catch { } 

             try{ data.lianxiren = Convert.ToString(dr["lianxiren"]) ;} catch { } 

             try{ data.pic1 = Convert.ToString(dr["pic1"]) ;} catch { } 

             try{ data.pic2 = Convert.ToString(dr["pic2"]) ;} catch { } 

             try{ data.pic3 = Convert.ToString(dr["pic3"]) ;} catch { } 

             try{ data.WorkersID = new Guid(dr["WorkersID"].ToString()) ;} catch { } 

             try{ data.bak1 = Convert.ToString(dr["bak1"]) ;} catch { } 

             try{ data.bak2 = Convert.ToString(dr["bak2"]) ;} catch { } 

             try{ data.bak3 = Convert.ToString(dr["bak3"]) ;} catch { } 

             try{ data.bak4 = Convert.ToString(dr["bak4"]) ;} catch { } 

             try{ data.bak5 = Convert.ToString(dr["bak5"]) ;} catch { } 

             try{ data.bak6 = Convert.ToString(dr["bak6"]) ;} catch { } 

             return data;
         }
         public static String GetPrimaryKey(DataRow dr)
         {
             String PrimaryKey="";

             try{ PrimaryKey = Convert.ToString(dr[TEInfoData.PRIMARYKEY_Field]) ;} catch { } 
                 return PrimaryKey;
         }

     }
     public class TEInfoDataDBOption
     {
         public static int Insert(TEInfoData d)
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("insert into TEInfo (");
             sql.Append("anzhuangTime, ");
             sql.Append("guishudi, ");
             sql.Append("hangye, ");
             sql.Append("shiyongdanwei, ");
             sql.Append("bufangweizhi, ");
             sql.Append("weihugongsi, ");
             sql.Append("remark, ");
             sql.Append("zhuceID, ");
             sql.Append("shengchanxuliehao, ");
             sql.Append("xinghao, ");
             sql.Append("fujianqingdan, ");
             sql.Append("wangluoinfo, ");
             sql.Append("shiyongdanweidizhi, ");
             sql.Append("lianxiren, ");
             sql.Append("pic1, ");
             sql.Append("pic2, ");
             sql.Append("pic3, ");
             sql.Append("WorkersID, ");
             sql.Append("bak1, ");
             sql.Append("bak2, ");
             sql.Append("bak3, ");
             sql.Append("bak4, ");
             sql.Append("bak5, ");
             sql.Append("bak6");
             sql.Append(") values (");
             sql.Append("'");
             sql.Append(d.anzhuangTime.ToString("yyyy-MM-dd HH:mm:ss"));
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.guishudi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.hangye.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.shiyongdanwei.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bufangweizhi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.weihugongsi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.remark.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.zhuceID.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.shengchanxuliehao.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.xinghao.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("");
             sql.Append(d.fujianqingdan.ToString());
             sql.Append("");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.wangluoinfo.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.shiyongdanweidizhi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.lianxiren.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.pic1.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.pic2.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.pic3.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.WorkersID.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bak1.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bak2.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bak3.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bak4.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bak5.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(d.bak6.ToString());
             sql.Append("'");
             sql.Append(")");
             return WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString());
         }
         public static int NewTE(string id,string zhuceID)
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("insert into TEInfo (");
             sql.Append("ID, ");             
             sql.Append("zhuceID");             
             sql.Append(") values (");
             sql.Append("'");
             sql.Append(id);
             sql.Append("'");
             sql.Append(", ");
             sql.Append("'");
             sql.Append(zhuceID);
             sql.Append("'");             
             sql.Append(")");
             return WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString());
         }
         public static int Update(TEInfoData d)
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("update TEInfo set ");
             sql.Append("anzhuangTime=");
             sql.Append("'");
             sql.Append(d.anzhuangTime.ToString("yyyy-MM-dd HH:mm:ss"));
             sql.Append("'");
             sql.Append(", ");
             sql.Append("guishudi=");
             sql.Append("'");
             sql.Append(d.guishudi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("hangye=");
             sql.Append("'");
             sql.Append(d.hangye.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("shiyongdanwei=");
             sql.Append("'");
             sql.Append(d.shiyongdanwei.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bufangweizhi=");
             sql.Append("'");
             sql.Append(d.bufangweizhi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("weihugongsi=");
             sql.Append("'");
             sql.Append(d.weihugongsi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("remark=");
             sql.Append("'");
             sql.Append(d.remark.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("zhuceID=");
             sql.Append("'");
             sql.Append(d.zhuceID.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("shengchanxuliehao=");
             sql.Append("'");
             sql.Append(d.shengchanxuliehao.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("xinghao=");
             sql.Append("'");
             sql.Append(d.xinghao.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("fujianqingdan=");
             sql.Append("");
             sql.Append(d.fujianqingdan.ToString());
             sql.Append("");
             sql.Append(", ");
             sql.Append("wangluoinfo=");
             sql.Append("'");
             sql.Append(d.wangluoinfo.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("shiyongdanweidizhi=");
             sql.Append("'");
             sql.Append(d.shiyongdanweidizhi.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("lianxiren=");
             sql.Append("'");
             sql.Append(d.lianxiren.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("pic1=");
             sql.Append("'");
             sql.Append(d.pic1.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("pic2=");
             sql.Append("'");
             sql.Append(d.pic2.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("pic3=");
             sql.Append("'");
             sql.Append(d.pic3.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("WorkersID=");
             sql.Append("'");
             sql.Append(d.WorkersID.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bak1=");
             sql.Append("'");
             sql.Append(d.bak1.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bak2=");
             sql.Append("'");
             sql.Append(d.bak2.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bak3=");
             sql.Append("'");
             sql.Append(d.bak3.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bak4=");
             sql.Append("'");
             sql.Append(d.bak4.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bak5=");
             sql.Append("'");
             sql.Append(d.bak5.ToString());
             sql.Append("'");
             sql.Append(", ");
             sql.Append("bak6=");
             sql.Append("'");
             sql.Append(d.bak6.ToString());
             sql.Append("'");
             sql.Append(" where ID=");
             sql.Append(d.ID.ToString());
             return WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString());
         }
         public static int Delete(TEInfoData d)
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("delete from TEInfo ");
             sql.Append(" where ID=");
             sql.Append(d.ID.ToString());
             return WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString());
         }
         public static DataTable DataTableSelect()
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("select * from TEInfo ");
             return WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString());
         }
         public static DataTable DataTableSelect(TEInfoData d)
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("select * from TEInfo where ID=");
             sql.Append(d.ID.ToString());
             return WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString());
         }
         public static TEInfoData GetTEInfo(string id)
         {
             StringBuilder sql = new StringBuilder();
             sql.Append("select * from TEInfo where ID= '"+id +"'");
             DataTable dt = WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString());
             if (dt.Rows.Count != 0)
             {
                 return TEInfoDataFactory.Construct(dt.Rows[0]);
             }
             return null;
         }
         public static int Set_fujianqingdan(string id,int fjqd)
         {
             StringBuilder sql = new StringBuilder();
             sql.Append("update TEInfo set ");             
             sql.Append("fujianqingdan=");
             sql.Append("");
             sql.Append(fjqd.ToString());
             sql.Append("");             
             sql.Append(" where ID='");
             sql.Append(id+"'");
             return WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString());
         }
         public static DataSet DataSetSelect()
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("select * from TEInfo ");
             return WFNetLib.ADO.SQLServerOP.DataSetSQL(sql.ToString());
         }
         public static SqlDataReader ReaderSelect(TEInfoData d)
         {
             StringBuilder sql=new StringBuilder();
             sql.Append("select * from TEInfo ");
             return WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString());
         }
     }
}